Category: Power BI

Find Out Drill down in Cognos Powerplay

Drill up & down operations allows moving up and down the hierarchy of categories in a dimension. To drill down means to go from a higher summary level into more details. Drilling up expands the focus of a report and moves into a lower detail level. In Cognos Powerplay you can Drill up and down the hierarchy tree in the following ways: • Hover the mouse pointer over a category you want to explore in more details and if the cursor changes to a plus sign, it means that the drill-down is available, and you can double click the category to drill down. • Alternatively, instead of double-clicking you can right-click on a selected category and select Drill Down. • Drill down by clicking the plus sign. • To drill back up go to the cube summary row or summary column and once the cursor changes to the plus sign with an up arrow, double-click it to go one level up. • Alternatively, instead of double click you can right-click on a selected category and select Drill Up. • Drill up by clicking the summary row. • It is also possible to drill up and down in a dimension viewer […]

Read More +

Benefits of using Microsoft Power BI

Power BI simplifies the process of extracting and presenting data in dynamic and interactive data visualizations. Power BI is a business analytics solution that lets you visualize your data and share insights across your embed them in your app or website. Power BI Benefits provides the following advantages: • View Power BI reports across multiple platforms and devices: Power BI brings the reports to your laptop or mobile device. Native apps are built and available for iOS (iPhone and iPad), Android and Windows devices. Wherever you have access to the internet, you’ll be able to view your reports instantly. • Integrates seamlessly with existing applications: Power BI integrates easily with your existing business environment allowing you to adopt analytics and reporting capabilities. Microsoft Azure Consultants can also help you in leveraging this intuitive tool to embed interactive visuals in your applications easily. • Rich personalized dashboards: The crowning feature of Power BI is the information dashboards, which can be customized to meet the exact need of any enterprise. You can easily embed the dashboards and BI reports in the applications to provide a unified user experience. • Publish reports securely: The tool helps you to set up automatic data refresh and publish […]

Read More +

Why adopt Microsoft Power BI

OAC

Microsoft Power BI (business intelligence) is a powerful analytics tool that helps to analyze data and share insights. With this technology, enterprises can monitor their business more closely and get instant answers with rich dashboards available for every device. Power BI is broken down into multiple tools: • Power Query to extract and transform. • Power Pivot to model and analyze. • Power View and Map to visualize data. Key features and benefits of Microsoft Power BI include: • The Q&A function. Sometimes the fastest way to get an answer from your data is to ask a question using natural language, and that’s exactly what Q&A allows users to do, making this feature a top-cited benefit in achieving self-service business intelligence. • Excel Integration. Power BI’s capability of Excel integration helps users to view and work with the raw data behind a Power BI visualization. • Dashboards, reports, and datasets are at the heart of Power BI. Users can create personalized dashboards, which combine on-premises and cloud-born data in a single view, allowing them to monitor their most important data enterprise-wide and from all their business apps. • The ability to easily embed BI and analytics in the app to […]

Read More +