Excel Dashboards & Reports For Dummies. Michael Alexander
241 244
242 245
243 246
244 247
245 248
246 249
247 250
248 251
249 252
250 253
251 254
252 255
253 256
254 257
255 258
256 259
257 260
258 261
259 262
260 263
261 264
262 265
263 266
264 267
265 268
266 269
267 270
268 271
269 272
270 273
271 274
272 275
273 276
274 277
275 278
276 279
277 280
278 281
279 283
280 284
281 285
282 286
283 287
284 288
285 289
286 290
287 291
288 292
289 293
290 294
291 295
292 296
293 297
294 298
295 299
296 300
297 301
298 303
299 304
300 305
301 306
302 307
303 308
304 309
305 310
306 311
307 312
308 313
309 314
310 315
311 316
312 317
313 318
314 319
315 320
316 321
317 323
318 324
319 325
320 326
321 327
322 328
323 329
324 330
325 331
326 332
327 333
328 334
329 335
330 336
331 337
332 339
333 340
334 341
335 342
336 343
337 344
338 345
339 346
340 347
341 348
342 349
343 350
344 351
345 352
346 353
347 354
348 355
349 356
350 357
351 358
352 359
353 360
354 361
355 362
356 363
357 364
358 365
Introduction
The term business intelligence (BI), coined by Howard Dresner of Gartner, Inc., describes the set of concepts and methods to improve business decision-making by using fact-based support systems. Practically speaking, BI is what you get when you analyze raw data and turn that analysis into knowledge. BI can help an organization identify cost-cutting opportunities, uncover new business opportunities, recognize changing business environments, identify data anomalies, and create widely accessible reports.
Over the past few years, the BI concept has overtaken corporate executives who are eager to turn impossible amounts of data into knowledge. As a result of this trend, whole industries have been created. Software vendors that focus on BI and dashboarding are coming out of the woodwork. New consulting firms touting their BI knowledge are popping up virtually every week. And even the traditional enterprise solution providers, like Business Objects and SAP, are offering new BI capabilities.
This need for BI has manifested itself in many forms. Most recently, it has come in the form of dashboard fever. Dashboards are reporting mechanisms that deliver business intelligence in a graphical form.
Maybe you’ve been hit with dashboard fever. Or maybe your manager is hitting you with dashboard fever. Nevertheless, you’re probably holding this book because you’re being asked to create BI solutions (that is, dashboards) in Excel.
Although many IT managers would scoff at the thought of using Excel as a BI tool, Excel is inherently part of the enterprise BI tool portfolio. Whether or not IT managers are keen to acknowledge it, most of the data