Microsoft Business Intelligence Tools for Excel Analysts
()
Currently unavailable
Currently unavailable
About this ebook
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts
The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process.
- Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel
- Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web
- Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms
You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.
Michael Alexander
Michael Alexander is the pseudonym of a nurse who has previously worked in the UK and New Zealand.
Read more from Michael Alexander
101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Microsoft Business Intelligence Tools for Excel Analysts Rating: 0 out of 5 stars0 ratingsExcel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5Excel Macros For Dummies Rating: 3 out of 5 stars3/5Excel Power Pivot & Power Query For Dummies Rating: 0 out of 5 stars0 ratingsExcel VBA Programming For Dummies Rating: 0 out of 5 stars0 ratingsConfessions of a School Nurse Rating: 4 out of 5 stars4/5Excel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5Excel Dashboards & Reports For Dummies Rating: 4 out of 5 stars4/5The Excel Analyst's Guide to Access Rating: 0 out of 5 stars0 ratingsJazz Age Jews Rating: 0 out of 5 stars0 ratingsExcel 2007 Dashboards and Reports For Dummies Rating: 3 out of 5 stars3/5The Colditz Hostages: Hitler's VIP Pawns Rating: 4 out of 5 stars4/5The Poetic Achievement of Ezra Pound Rating: 4 out of 5 stars4/5The Seventh Day Rating: 0 out of 5 stars0 ratings
Related to Microsoft Business Intelligence Tools for Excel Analysts
Enterprise Applications For You
Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsQuickBooks 2024 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsThe Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratingsThe New Email Revolution: Save Time, Make Money, and Write Emails People Actually Want to Read! Rating: 5 out of 5 stars5/5Excel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5Create Income through Self-Publishing: An Author's Approach on Generating Wealth by Self-Publishing Rating: 5 out of 5 stars5/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2019 For Dummies Rating: 3 out of 5 stars3/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Excel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsEssential Office 365 Third Edition: The Illustrated Guide to Using Microsoft Office Rating: 3 out of 5 stars3/5Microsoft Outlook 2016/2019/365 User Guide Rating: 5 out of 5 stars5/5Learn SQLite in 24 Hours Rating: 0 out of 5 stars0 ratingsChange Management for Beginners: Understanding Change Processes and Actively Shaping Them Rating: 5 out of 5 stars5/5Evernote Essentials Guide (Boxed Set): Evernote Guide For Beginners for Organizing Your Life Rating: 3 out of 5 stars3/5
Reviews for Microsoft Business Intelligence Tools for Excel Analysts
0 ratings0 reviews