Business Intelligence For Dummies

Author: Swain Scheps

Publisher: John Wiley & Sons

ISBN: 1118051416

Category: Computers

Page: 388

View: 2788

You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in making the right decisions about your business. But you’ve heard at least a dozen definitions of what it is, and heard of at least that many BI tools. Where do you start? Business Intelligence For Dummies makes BI understandable! It takes you step by step through the technologies and the alphabet soup, so you can choose the right technology and implement a successful BI environment. You'll see how the applications and technologies work together to access, analyze, and present data that you can use to make better decisions about your products, customers, competitors, and more. You’ll find out how to: Understand the principles and practical elements of BI Determine what your business needs Compare different approaches to BI Build a solid BI architecture and roadmap Design, develop, and deploy your BI plan Relate BI to data warehousing, ERP, CRM, and e-commerce Analyze emerging trends and developing BI tools to see what else may be useful Whether you’re the business owner or the person charged with developing and implementing a BI strategy, checking out Business Intelligence For Dummies is a good business decision.

Microsoft Business Intelligence For Dummies

Author: Ken Withee

Publisher: John Wiley & Sons

ISBN: 9780470606346

Category: Computers

Page: 432

View: 4536

Learn to create an effective business strategy using Microsoft's BI stack Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office Suite, PerformancePoint Server, and SQL Server, among others. With so much jargon and so many technologies involved, Microsoft Business Intelligence For Dummies provides a much-needed step-by-step explanation of what's involved and how to use this powerful package to improve your business. Microsoft Business Intelligence encompasses a broad collection of tools designed to help business owners and managers direct the enterprise effectively This guide provides an overview of SharePoint, PerformancePoint, the SQL Server suite, Microsoft Office, and the BI development technologies Explains how the various technologies work together to solve functional problems Translates the buzzwords and shows you how to create your business strategy Examines related technologies including data warehousing, data marts, Online Analytical Processing (OLAP), data mining, reporting, dashboards, and Key Performance Indicators (KPIs) Simplifies this complex package to get you up and running quickly Microsoft Business Intelligence For Dummies demystifies these essential tools for enterprise managers, business analysts, and others who need to get up to speed.

Competitive Intelligence For Dummies

Author: James D. Underwood

Publisher: John Wiley & Sons

ISBN: 1118450981

Category: Business & Economics

Page: 384

View: 7266

Make competitive intelligence part of your business practice—and be on the cutting edge Competitive intelligence is the art of defining, gathering, analyzing, and distributing intelligence about products, customers, competitors, individuals, concepts, information, ideas, or data needed to support executives and managers in making strategic decisions for an organization. Competitive Intelligence For Dummies introduces you to this fascinating subject and gives you the tools you need to incorporate it into your business decision-making process. Conducted within an organization, competitive intelligence serves as a catalyst in planning and strategic growth. It is part of the value chain that converts gathered data to actionable information that results in strategic decisions. Competitive Intelligence For Dummies helps readers gather valuable information on the competition, the operational environment, and the target customer. It also explains how to carefully analyze and use this information in decision making processes to gain market share and stay on the cutting edge of an industry. Whether you are just starting a business, venturing into new areas with your existing company, or looking to gain ground on a key competitor, Competitive Intelligence For Dummies gives you insight on how to gather valuable information on not only your competitors, but on your market and key customer base. Gets you up to speed on how to locate, collect, and process competitive intelligence Shows you how to carefully analyze competitive intelligence and disseminate it throughout your organization Illustrates how competitive intelligence can help you gain market share If you're a business owner, analyst, manager, or researcher, Competitive Intelligence For Dummies gives you and your business an edge.

Data Warehousing For Dummies

Author: Thomas C. Hammergren

Publisher: John Wiley & Sons

ISBN: 9780470482926

Category: Computers

Page: 384

View: 1242

Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to: Analyze top-down and bottom-up data warehouse designs Understand the structure and technologies of data warehouses, operational data stores, and data marts Choose your project team and apply best development practices to your data warehousing projects Implement a data warehouse, step by step, and involve end-users in the process Review and upgrade existing data storage to make it serve your needs Comprehend OLAP, column-wise databases, hardware assisted databases, and middleware Use data mining intelligently and find what you need Make informed choices about consultants and data warehousing products Data Warehousing For Dummies, 2nd Edition also shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track. You’ll find it’s the most useful source of data on the topic!

Microsoft Business Intelligence Tools for Excel Analysts

Author: Michael Alexander,Jared Decker,Bernard Wehbe

Publisher: John Wiley & Sons

ISBN: 1118821521

Category: Computers

Page: 384

View: 5208

Introduces business analysts to the toolset and reporting capabilities that can be used to source and incorporate large datasets in analytics, including PowerPivot, SQL Server, and SharePoint, covering such topics as how to move data between these tools,how to leverage relational databases, and creating visualizations and dashboards.

Emotional Intelligence For Dummies

Author: Steven J. Stein

Publisher: John Wiley & Sons

ISBN: 0470676248

Category: Business & Economics

Page: 360

View: 9768

Being aware of and in control of your emotions is one of the keys to success in life -- both professionally and personally. Emotional Intelligence For Dummies will show you how to take control of your emotions rather than letting your emotions control you! Discover how developing your emotional intelligence can further your relationships with others, in the workplace and at home. Emotional awareness is also a critical skill for career success, and Dr. Stein provides practical exercises for developing this skill and achieving your professional and personal goals. He also provides valuable insights into how emotional intelligence can be applied to raising children and teenagers and realizing personal happiness. Full of lively anecdotes and practical advice, Emotional Intelligence For Dummies is the ideal book for anyone who wants to get smart about their feelings and reach the next level at work and at home. Manage your emotions - identify your feelings, determine what beliefs cause negative emotions, and stop self-destructive behaviors Discover the power of empathy - read other people's emotions through facial cues and body language and show them you understand their feelings Thrive at work - find a job that's right for you, overcome hassles and fears, and develop your leadership skills Build and sustain meaningful relationships - discover how to take your partner's emotional temperature and manage emotions to grow closer Raise an emotionally intelligent child - keep your cool with your child, coax shy children out of their shells, and get your child to be less aggressive and defiant

Artificial Intelligence For Dummies

Author: John Paul Mueller,Luca Massaron

Publisher: John Wiley & Sons

ISBN: 1119467586

Category: Computers

Page: 336

View: 8828

Step into the future with AI The term "Artificial Intelligence" has been around since the 1950s, but a lot has changed since then. Today, AI is referenced in the news, books, movies, and TV shows, and the exact definition is often misinterpreted. Artificial Intelligence For Dummies provides a clear introduction to AI and how it’s being used today. Inside, you’ll get a clear overview of the technology, the common misconceptions surrounding it, and a fascinating look at its applications in everything from self-driving cars and drones to its contributions in the medical field. Learn about what AI has contributed to society Explore uses for AI in computer applications Discover the limits of what AI can do Find out about the history of AI The world of AI is fascinating—and this hands-on guide makes it more accessible than ever!

Business Analysis for Business Intelligence

Author: Bert Brijs

Publisher: CRC Press

ISBN: 1439858373

Category: Business & Economics

Page: 400

View: 2862

Aligning business intelligence (BI) infrastructure with strategy processes not only improves your organization's ability to respond to change, but also adds significant value to your BI infrastructure and development investments. Until now, there has been a need for a comprehensive book on business analysis for BI that starts with a macro view and gradually narrows it down to real-world tips, templates, and discussion material BI analysts need to know. Covering the concepts, tools, and background required for successful BI projects, Business Analysis for Business Intelligence describes how to use business intelligence to improve your analysis activities. It outlines a proven framework for developing data models and solutions that fit your organization’s strategy. Explaining how to avoid common pitfalls, it demonstrates how to use continuous improvement to create a strategic knowledge organization and establish a competitive advantage. Links proven theories with practical insights Describes the questions you need to ask yourself or the client when turning data into information Includes discussion items and templates suitable for both IT and business professionals Illustrates the root causes behind poor performance management Outlines the steps needed to get your BI project started correctly The book details a framework based on time-tested theories, empirical data, and the author’s experience analyzing strategic processes in dozens of organizations across a range of industries—including financial, logistics, food production, health, telecom, government, and retail. Providing you with the tools to achieve enduring success, the book can help your organization develop successful BI projects and fine-tune them to match the strategic decision making process in your organization.

Data Visualization For Dummies

Author: Mico Yuk,Stephanie Diamond

Publisher: John Wiley & Sons

ISBN: 1118502922

Category: Computers

Page: 256

View: 1275

A straightforward, full-color guide to showcasing data so your audience can see what you mean, not just read about it Big data is big news! Every company, industry, not-for-profit, and government agency wants and needs to analyze and leverage datasets that can quickly become ponderously large. Data visualization software enables different industries to present information in ways that are memorable and relevant to their mission. This full-color guide introduces you to a variety of ways to handle and synthesize data in much more interesting ways than mere columns and rows of numbers. Learn meaningful ways to show trending and relationships, how to convey complex data in a clear, concise diagram, ways to create eye-catching visualizations, and much more! Effective data analysis involves learning how to synthesize data, especially big data, into a story and present that story in a way that resonates with the audience This full-color guide shows you how to analyze large amounts of data, communicate complex data in a meaningful way, and quickly slice data into various views Explains how to automate redundant reporting and analyses, create eye-catching visualizations, and use statistical graphics and thematic cartography Enables you to present vast amounts of data in ways that won't overwhelm your audience Part technical manual and part analytical guidebook, Data Visualization For Dummies is the perfect tool for transforming dull tables and charts into high-impact visuals your audience will notice...and remember.

BusinessObjects XI Release 2 For Dummies

Author: Derek Torres,Stuart Mudie,Julie Albaret

Publisher: John Wiley & Sons

ISBN: 9781118051986

Category: Computers

Page: 344

View: 671

BusinessObjects may seem like a dauntingly complex topic, but BusinessObjects XI Release 2 For Dummies makes is a snap. Even if you're new to business intelligence tools, this user-friendly guide makes it easy to access, format and share data, analyze the information this data contains, and measure your organization’s performance. In no time, you'll be finding your way around Universes to see how everything is shaping up, viewing and creating reports, building powerful queries on your organizations database, and measuring your company's performance using BusinessObjects XI Release 2. This completely jargon-free handbook will put you in complete control of the ways and means of a truly exciting and powerful suite of business intelligence tools. Discover how to: Make business decisions with help from BusinessObjects Use BusinessObjects XI wizards Perform a server installation Create and define a Universe Set up desktop reporting Customize and use InfoView Measure performance with Dashboard and Analytics Take advantage of data marts and understand how they fit into your BusinessObjects system Created by a team with more than 15 years combined experience working with BusinessObjects tools, BusinessObjects XI Release 2 For Dummies comes complete with several short lists of useful information, including tips on how to prepare for a successful BusinessObjects integration and helpful resources beyond the pages of this book. You'll also find an overview of Crystal Reports, BusinessObjects’ companion reporting tool.

SAS For Dummies

Author: Stephen McDaniel,Chris Hemedinger

Publisher: John Wiley & Sons

ISBN: 9781118044018

Category: Computers

Page: 408

View: 3649

Created in partnership with SAS, this book explores SAS, a business intelligence software that can be used in any business setting or enterprise for data delivery, reporting, data mining, forecasting, statistical analysis, and more SAS employee and technologist Stephen McDaniel combines real-world expertise and a friendly writing style to introduce readers to SAS basics Covers crucial topics such as getting various types of data into the software, producing reports, working with the data, basic SAS programming, macros, and working with SAS and databases

Business Intelligence Guidebook

From Data Integration to Analytics

Author: Rick Sherman

Publisher: Newnes

ISBN: 0124115284

Category: Computers

Page: 550

View: 6499

Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors’ tools lies the essential, yet poorly-understood layer of architecture, design and process. Without this knowledge, Big Data is belittled – projects flounder, are late and go over budget. Business Intelligence Guidebook: From Data Integration to Analytics shines a bright light on an often neglected topic, arming you with the knowledge you need to design rock-solid business intelligence and data integration processes. Practicing consultant and adjunct BI professor Rick Sherman takes the guesswork out of creating systems that are cost-effective, reusable and essential for transforming raw data into valuable information for business decision-makers. After reading this book, you will be able to design the overall architecture for functioning business intelligence systems with the supporting data warehousing and data-integration applications. You will have the information you need to get a project launched, developed, managed and delivered on time and on budget – turning the deluge of data into actionable information that fuels business knowledge. Finally, you’ll give your career a boost by demonstrating an essential knowledge that puts corporate BI projects on a fast-track to success. Provides practical guidelines for building successful BI, DW and data integration solutions. Explains underlying BI, DW and data integration design, architecture and processes in clear, accessible language. Includes the complete project development lifecycle that can be applied at large enterprises as well as at small to medium-sized businesses Describes best practices and pragmatic approaches so readers can put them into action. Companion website includes templates and examples, further discussion of key topics, instructor materials, and references to trusted industry sources.

Excel Data Analysis For Dummies

Author: Stephen L. Nelson,E. C. Nelson

Publisher: John Wiley & Sons

ISBN: 1119077168

Category: Computers

Page: 384

View: 9024

Want to take the guesswork out of analyzing data? Let Excel do all the work for you! Data collection, management and analysis is the key to making effective business decisions, and if you are like most people, you probably don't take full advantage of Excel's data analysis tools. With Excel Data Analysis For Dummies, 3rd Edition, you'll learn how to leverage Microsoft Excel to take your data analysis to new heights by uncovering what is behind all of those mind-numbing numbers. The beauty of Excel lies in its functionality as a powerful data analysis tool. This easy-to-read guide will show you how to use Excel in conjunction with external databases, how to fully leverage PivotTables and PivotCharts, tips and tricks for using Excel's statistical and financial functions, how to visually present your data so it makes sense, and information about the fancier, more advanced tools for those who have mastered the basics! Once you're up to speed, you can stop worrying about how to make use of all that data you have on your hands and get down to the business of discovering meaningful, actionable insights for your business or organization. Excel is the most popular business intelligence tool in the world, and the newest update – Microsoft Excel 2016 – features even more powerful features for data analysis and visualization. Users can slice and dice their data and create visual presentations that turn otherwise indecipherable reports into easy-to-digest presentations that can quickly and effectively illustrate the key insights you are seeking. Fully updated to cover the latest updates and features of Excel 2016 Learn useful details about statistics, analysis, and visual presentations for your data Features coverage of database and statistics functions, descriptive statistics, inferential statistics, and optimization modeling with Solver Helps anyone who needs insight into how to get things done with data that is unwieldy and difficult to understand With Excel Data Analysis For Dummies, 3rd Edition, you'll soon be quickly and easily performing key analyses that can drive organizational decisions and create competitive advantages.

Data Science For Dummies

Author: Lillian Pierson

Publisher: John Wiley & Sons

ISBN: 1119327644

Category: Computers

Page: 384

View: 9909

Discover how data science can help you gain in-depth insight into your business - the easy way! Jobs in data science abound, but few people have the data science skills needed to fill these increasingly important roles. Data Science For Dummies is the perfect starting point for IT professionals and students who want a quick primer on all areas of the expansive data science space. With a focus on business cases, the book explores topics in big data, data science, and data engineering, and how these three areas are combined to produce tremendous value. If you want to pick-up the skills you need to begin a new career or initiate a new project, reading this book will help you understand what technologies, programming languages, and mathematical methods on which to focus. While this book serves as a wildly fantastic guide through the broad, sometimes intimidating field of big data and data science, it is not an instruction manual for hands-on implementation. Here’s what to expect: Provides a background in big data and data engineering before moving on to data science and how it's applied to generate value Includes coverage of big data frameworks like Hadoop, MapReduce, Spark, MPP platforms, and NoSQL Explains machine learning and many of its algorithms as well as artificial intelligence and the evolution of the Internet of Things Details data visualization techniques that can be used to showcase, summarize, and communicate the data insights you generate It's a big, big data world out there—let Data Science For Dummies help you harness its power and gain a competitive edge for your organization.

Predictive Analytics For Dummies

Author: Dr. Anasse Bari,Mohamed Chaouchi,Tommy Jung

Publisher: John Wiley & Sons

ISBN: 1119267013

Category: Business & Economics

Page: 456

View: 828

Use Big Data and technology to uncover real-world insights You don't need a time machine to predict the future. All it takes is a little knowledge and know-how, and Predictive Analytics For Dummies gets you there fast. With the help of this friendly guide, you'll discover the core of predictive analytics and get started putting it to use with readily available tools to collect and analyze data. In no time, you'll learn how to incorporate algorithms through data models, identify similarities and relationships in your data, and predict the future through data classification. Along the way, you'll develop a roadmap by preparing your data, creating goals, processing your data, and building a predictive model that will get you stakeholder buy-in. Big Data has taken the marketplace by storm, and companies are seeking qualified talent to quickly fill positions to analyze the massive amount of data that are being collected each day. If you want to get in on the action and either learn or deepen your understanding of how to use predictive analytics to find real relationships between what you know and what you want to know, everything you need is a page away! Offers common use cases to help you get started Covers details on modeling, k-means clustering, and more Includes information on structuring your data Provides tips on outlining business goals and approaches The future starts today with the help of Predictive Analytics For Dummies.

Microsoft Data Mining

Integrated Business Intelligence for e-Commerce and Knowledge Management

Author: Barry de Ville

Publisher: Elsevier

ISBN: 0080491847

Category: Computers

Page: 320

View: 3109

Microsoft Data Mining approaches data mining from the particular perspective of IT professionals using Microsoft data management technologies. The author explains the new data mining capabilities in Microsoft's SQL Server 2000 database, Commerce Server, and other products, details the Microsoft OLE DB for Data Mining standard, and gives readers best practices for using all of them. The book bridges the previously specialized field of data mining with the new technologies and methods that are quickly making it an important mainstream tool for companies of all sizes. Data mining refers to a set of technologies and techniques by which IT professionals search large databases of information (such as those contained by SQL Server) for patterns and trends. Traditionally important in finance, telecommunication, and other information-intensive fields, data mining increasingly helps companies better understand and serve their customers by revealing buying patterns and related interests. It is becoming a foundation for e-commerce and knowledge management. Unique book on a hot data management topic Part of Digital Press's SQL Server and data mining clusters Author is an expert on both traditional and Microsoft data mining technologies

Mastering Business Intelligence with MicroStrategy

Author: Dmitry Anoshin,Himani Rana,Ning Ma

Publisher: Packt Publishing Ltd

ISBN: 1785886266

Category: Computers

Page: 396

View: 8452

Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between BI tools and implementation/integration processes with big data and predictive analytics using this comprehensive guide to MicroStrategy 10 Highly practical, example-rich guide that lets you implement business intelligence with MicroStrategy 10 in your organization Create the best user experience with BI dashboards using MicroStrategy using this up-to-date, comprehensive guide Who This Book Is For This book is intended for BI, DWH, ETL developers, BI/DWH/Analytics managers, analysts, and business users who already have MicroStrategy in their organization and want to take it to the next level in order to increase performance and improve user experience. In addition, it helps the reader to migrate from MicroStrategy 9 to MicroStrategy 10 and to start using the new capabilities. What You Will Learn Explore various visualization techniques for presenting analyzed data Customize MicroStrategy in order to meet your business requirements Develop and design mobile dashboards Use the advanced techniques such as designing reports, documents and interactive dashboards for building dashboards Understand the concepts of data discovery and Desktop capabilities Explore the best practices for Microstrategy system administration Find and fix issues based on connections, environment or documents Integrate third party ESRI map tools with MicroStrategy to create geo based reports In Detail Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. It lets you various delivery methods such as the Web, desktops, and mobiles. Using real-world BI scenarios, this book helps you to implement Business Analytics solutions in big e-commerce companies. It kicks off with MicroStrategy 10 features and then covers schema design models and techniques. Building upon your existing knowledge, the book will teach you advanced techniques for building documents and dashboards. It further teaches various graphical techniques for presenting data for analysis using maps, graphs, and advanced charts. Although MicroStrategy has rich functionality, the book will show how to customize it in order to meet your business requirements. You will also become familiar with the native analytical functions that will help you to maximize the impact of BI solutions with powerful predictive analytics. Furthermore, the book will focus on MicroStrategy Mobile Analytics along with data discovery and desktop capabilities such as connecting various data sources and building interactive dashboards. The book will also uncover best practices, troubleshooting techniques for MicroStrategy system administration, and also security and authentication techniques. Lastly, you will learn to use Hadoop for MicroStrategy reporting. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. Style and approach This book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture for real world scenario, using Microstrategy 10, best practices and collected experience working with BI, predictive analytics, and Microstrategy and big data.

Excel Dashboards and Reports for Dummies

Author: Michael Alexander

Publisher: John Wiley & Sons

ISBN: 1119076773

Category: Computers

Page: 384

View: 2667

Make the most of your data using the power of Excel When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data—and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values. As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds. Analyze and report on large amounts of data in a meaningful way Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting!

Tableau For Dummies

Author: Molly Monsey,Paul Sochan

Publisher: John Wiley & Sons

ISBN: 1119134838

Category: Computers

Page: 288

View: 2667

Make your data work for you! Tableau For Dummies brings order to the chaotic world of data. Understanding your data and organizing it into formats and visualizations that make sense to you are crucial to making a real impact on your business with the information that's already at your fingertips. This easy-to-use reference explores the user interface, and guides you through the process of connecting your data sources to the software. Additionally, this approachable, yet comprehensive text shows you how to use graphs, charts, and other images to bring visual interest to your data, how to create dashboards from multiple data sources, and how to export the visualizations that you have developed into multiple formats that translate into positive change for your business. The mission of Tableau Software is to grant you access to data that, when put into action, will help you build your company. Learning to use the data available to you helps you make informed, grounded business decisions that can spell success for your company. Navigate the user interface to efficiently access the features you need Connect to various spreadsheets, databases, and other data sources to create a multi-dimensional snapshot of your business Develop visualizations with easy to use drag and drop features Start building your data with templates and sample workbooks to spark your creativity and help you organize your information Tableau For Dummies is a step-by-step resource that helps you make sense of the data landscape—and put your data to work in support of your business.

Excel Power Pivot and Power Query For Dummies

Author: Michael Alexander

Publisher: John Wiley & Sons

ISBN: 1119210666

Category: Computers

Page: 288

View: 1605

A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. Demonstrates how Power Query is used to discover, connect to, and import your data Shows you how to use PowerPivot to model data once it's been imported Offers guidance on using these tools to make analyzing data easier Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.