Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.
At the end of the course, participants would learn/use/acquire the following techniques/knowledge:
The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 to create self-service data models and reports. This course is designed for customers who are interested in learning Self-Service BI tools and techniques.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Importing data present in other formats|
Importing data present in other formatsPreview
|Section 3: Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets|
Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
|Section 4: Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle My|
Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle My
|Section 5: Formatting columns and modifying data types dynamically ; using simple DAX comma|
Formatting columns and modifying data types dynamically ; using simple DAX comma
|Section 6: Linking Excel to external data sources / websites|
Linking Excel to external data sources / websites
|Section 7: Exploring new components of Charts in MS Excel|
Exploring new components of Charts in MS Excel Part 1
Exploring new components of Charts in MS Excel Part 2
|Section 8: Introduction to Power Pivot tool to create instant Data Models and link tables|
Introduction to Power Pivot tool to create instant Data Models and link tables
Introduction to Power Pivot tool to create instant Data Models Part 2
|Section 9: Overview of visualization of geographical data|
Overview of visualization of geographical data
|Section 10: Additional Material|
|Section 11: Exercises|
|Section 12: Mock Test|
|Section 13: Course Conclusion|
Bonus Lecture on The Inside Story: Self-Service-BI in MS Excel 2013
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.