The ability to analyse data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.
In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.
Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.
Data can be accesses from anywhere
Access data from hundreds of supported on-premises and cloud-based sources, such as Dynamics 365, Sales force, Azure SQL DB, Excel, and SharePoint. Ensure it’s always up to date with automated, incrementalrefreshes. Power BI Desktop enables you to develop deep, actionable insightsfor a broad range of scenarios.
Prep and model your data with ease
Data prep can take most of your time, but it doesn’t have towith data modelling tools. Reclaim hours in your day using the self-servicePower Query experience familiar to millions of Excel users. Ingest, transform,integrate and enrich data in Power BI.
Provide advanced analytics with the familiarity of Excel
Dig deeper into data and find patterns you may have otherwise missed that lead to actionable insights. Use features like quick measures, grouping, forecasting, and clustering. Give advanced users full control over their model using powerful DAX formula language. If you’re familiar with Excel, you’ll feel at home in Power BI.
Create interactive reports customized for your business
Create stunning reports with interactive data visualizations. Tell your data story using a drag-and-drop canvas and hundreds of modern data visuals from Microsoft and partners—or create your own, using the Power BI open source custom visuals framework. Design your report with theming, formatting, and layout tools.
Author for everyone, anywhere
Get visual analytics to the people who need it. Createmobile-optimized reports for viewers to consume on the go. Publish from PowerBI Desktop to the cloud or on-premises. Embed reports created in Power BIDesktop into existing apps or websites.
Microsoft data management and analytics certification
MCSE: Data Management and Analytics
Demonstrate your broad skill sets in SQL administration,building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments.
What is involved?
Earning an MCSE: Data Management and Analytics certification qualifies you for such jobs as database analyst, database designer, and business intelligence analyst.
STEP 1 - SKILLS
Earn your MCSA in SQL Server 2012/2014, or SQL 2016 Database Administration, Database Development, BI Development, Machine Learning, BI Reporting or Data Engineering with Azure.
STEP 2 - EXAMS
Pass 1 required exam. Be sure to explore the exam prep resources.
Exam 70-464/Course 20464
Developing Microsoft SQL Server Databases
This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types,and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.
Exam 70-465/Course 20465
Designing Database Solutions for Microsoft SQL Server
This exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs.
Exam 70-467/Course 20467
Designing Business Intelligence Solutions with Microsoft SQL Server
This exam is intended for business intelligence (BI)architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.
Exam 70-762/Course 20762
Developing SQL Databases
This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, datatypes, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks
Exam 70-767/Course 20767
Implementing a Data Warehouse using SQL
This exam is intended for extract, transform, and load (ETL)and data warehouse developers who create business intelligence (BI) solutions.Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.
Exam 70-768/Course 20768
Developing SQL Data Models
This exam is intended for business intelligence (BI)developers who focus on creating BI solutions that require implementing multi dimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.
Exam 70-777/Course 20777
Implementing Microsoft Azure Cosmos DB Solutions
Candidates for this exam are developers and architects who leverage Azure Cosmos DB. Candidates should understand fundamental concepts of partitioning, replication, and resource governance for building and reconfigurable applications that are agnostic of a Cosmos DB API. Candidates should also have basic working knowledge of the Cosmos DB SQL API.
Candidates for this exam design, build, and troubleshoot Cosmos DB solutions that meet business and technical requirements.
STEP 3 - CERTIFICATION
Earn your MCSE: Data Management and Analytics certification.
STEP 4 - CONTINUING EDUCATION
Explore other certifications to broaden and advance skills.
Certification Exams and prep resources
Step 1: Skills
Earn your MCSA certification.
Step 2: Exams
Pass one of the following exams. Be sure to explore the examprep resources.
Step 3: Completion
Complete an MCSE in Data Management and Analytics by passingthe required exams in Step 2.
Step 4: Continuing Education
Explore other certifications to broaden and advance skills.