Data Analysis with Microsoft


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.

 




By haripriya.krishnakum Krishnakumar | 18 Oct 2019 | 0 Comments