MicroStrategy BI

MicroStrategy BI training course

1. Microstrategy BI Sudheer Reddy P
2. Before We Start  Sudheer Reddy P  Participants – What do you do? – Why are you taking this course?  Course details – Theory + practice 2 Microstrategy
3. Trainer BOI Name : Sudheer Reddy P Total IT Experience: 7 Years Relevant Experience: 5+ years in Microstrategy Skills: Microstrategy, Power Bi and Hadoop 3 Microstrategy
4. Before we begin – Schedule  Starts 09:30  Ends 16:30  Lunch – 60 mins  Break 4 – 10-15 mins AM – 10-15 mins PM Microstrategy
5. Course details Course title: QT Programming  Scope: – By the end of this training, participants will be able to:  Install and configure MicroStrategy  Use MicroStrategy to perform predictive analytics on large data sets  Access and analyze data from data warehouses, Excel files, etc  Create elaborate reports and dashboards – Trainer evaluation sheet  Sent to your email inboxes – Course certificates of completion  Sent to your email inboxes 5 Microstrategy
6. QT Programming Topic title • Introduction • Installing and Configuring MicroStrategy • Overview of MiroStrategy Features and Design • Understanding MicroStrategy Hierarchy and Grouping • Connecting to a Data Source • Designing Schema Objects • Creating Application Objects • Overview of the Report and Query Execution Workflow • Creating a Report • Manipulating Report Data • Creating a Dashboard • Troubleshooting • Summary and Conclusion 6 Microstrategy
7.  Introduction – What is Microstrategy? – Why Microstrategy? – Microstrategy benefits? – Overview of Microstrategy features  Installing and Configuring MicroStrategy – How to download and install the Microstrategy – How configure Microstrategy – How change Project Configuration Download link for Microstrategy Desktop: – https://www.microstrategy.com/us/get-started/desktop 7 Microstrategy
8.  Installing and Configuring MicroStrategy – Follow below steps to download and install the Microstrategy. Before installation check the system requirements. Operating system – Windows 7, 10 – 64-bit /Linux RAM – Minimum 8GB Adobe Reader 10/11 version Hard disk space – minimum 100GB 8 Microstrategy
9. Step1 :- Download the Microstrategy software from the site. 9 Microstrategy
10. Step 2:- After downloading extract the microstrategy .zip file Step 3:- In the above screen short there are two components desktop and developer tool. 10 Microstrategy
11. Step 4:- install desktop 11 Microstrategy
12. 12 Microstrategy
13. Step 5: Installation of developer tool. 13 Microstrategy
14. 14 Microstrategy
15. 15 Microstrategy
16. 16 Microstrategy
17. 17 Microstrategy
18. 18 Microstrategy
19. 19 Microstrategy
20. 20 Microstrategy
21. 21 Microstrategy
22. 22 Microstrategy
23. 23 Microstrategy
24. 24 Microstrategy
25. 25 Microstrategy
26. 26 Microstrategy
27. 27 Microstrategy
28. 28 Microstrategy
29. 29 Microstrategy
30. 30 Microstrategy
31. 31 Microstrategy
32. 32 Microstrategy
33. After installation Goto -> Start menu -> Developer -> click the developer it open like this. 33 Microstrategy
34.  MicroStrategy Hierarchy and Grouping – what is Hierarchy ? – How to use Hierarchy is Microstrategy? – What is Grouping – How it will use full in the Microstrategy? – Types of Groups 1. Custom Groups 2. Consolidations  Connecting to a Data Source – How to connect data sources – How to import are export the data from Microstrategy – How many types data extraction in Microstrategy 34 Microstrategy
35. 35 Microstrategy
36.  Types of Objects – Configuration Objects – Public Objects – Schema Objects – Report Objects – What is use of the objects? – How will we use in the Microstrategy?  Metric Types – Simple Metric – Compound Metric – Conditional Metric – Level Metric 36 Microstrategy
37.  Attribute Types – Simple – Derived  Report Types – Grid – Freeform SQL  OLAP Services(Online Analytical Processing) – Aliasing – Banding – Page-by – Sorting – Subtotals – Thresholds 37 Microstrategy
38.  Basic Reporting – Report Types – Drilldown – Creating Metrics  Advanced Reporting – Creating Derived Metrics – Creating Filters – Advanced Filters 1. Search Box 2. Radio Button 3. Drop down – Refreshing Reports – Intelligent Cubes 38 Microstrategy
39. 39 Microstrategy
40. 40 Microstrategy
41. 41 Microstrategy
42. 42 Microstrategy
43.  Report Types Grid Reports Graph Reports Combined Reports How to create Report? How Use the report in the Document? How to Troubleshoot the reports? 43 Microstrategy
44. 44 Microstrategy
45. 45 Microstrategy
46. 46 Microstrategy
47.  Dashboards What is dashboard? What is use of the dashboards? How to create the dashboards? 47 Microstrategy
48. 48 Microstrategy
49. 49 Microstrategy
50.  Data Modeling Data modeling is the structuring of an organization's data assets into an applicable logical model. Modeling is creating information that describes another set of data. In a BI platform, the logical data model is designed and built using current user requirements. There are two approaches to modeling in MicroStrategy: 1. Create project models from MicroStrategy Developer 2. Create ad-hoc models from MicroStrategy Web Create Project Models via Architect in MicroStrategy Developer 1. In Developer, select a project and go to Schema > Architect. 2. Connect to a database instance and drag tables into the canvas. 3. Select the attributes and facts from that table. Create the relationships and hierarchies. 50 Microstrategy
51. 1. How to create Lookup tables? 2. How to create Fact Tables? 3. How to create Logical Tables? 4. How to create Relationships? 5. what is Homogeneous mapping? 6. what is Heterogeneous mapping? 51 Microstrategy
52. 52 Microstrategy
53. 5. Click Save and Update the Schema. 6. Exit Architect. 7. In Developer, use the individual editors to create and edit other model objects. For example, edit the attributes 53 Microstrategy
54.  Create Ad-Hoc Models via Import Data in MicroStrategy Web 1. In MicroStrategy Web, click Create > Add External Data. 2. Connect to a data source and fetch the requisite tables. 54 Microstrategy
55. 3. Fetch the requisite data from the tables in the query builder 55 Microstrategy
56. 4. Bring in tables from different sources and create the models. 56 Microstrategy
57. 5. Change relationships for the tables. 6. Publish the cube. 57 Microstrategy
58.  Microstrategy Architecture Generally MicroStrategy follows 3 kinds of architectures. - 2 - Tier Architecture - 3 - Tier Architecture - N - Tier Architecture  2-Tier Architecture (Direct Mode) In the two tier architecture the client connects directly to the metadata and data Warehouse. A 2-tier connection mode connects the project to the metadata via an Open Database Connectivity (ODBC) data source name (DSN). The following diagram shows the 2-tier architecture. 58 Microstrategy
59.  3-Tier Architecture (Server Mode) In the 3-tier architecture the client connects to the metadata and the data Warehouse through the Intelligence Server. Following diagram shows the 3-tier architecture. 59 Microstrategy
60.  Multi-Tier Architecture (Server Mode) In the Multi-tier architecture the client connects to the Intelligence Server (IS) through the Web server from the web browser. The IS in turn connects to the metadata and the data Warehouse. Following diagram shows the 3-tier architecture. 60 Microstrategy
61. MicroStrategy - Data Marts  What is data mart? Data mart is a smaller form of data warehouse, which serves some specific needs on data analysis.  What is the use of data marts?  How to create data marts? 61 Microstrategy
62. THANK YOU 62 Microstrategy
No comments...
none

Related Slides