Posts

Showing posts from September, 2020

What is meant by MSBI?

Image
MSBI stands for Microsoft Business Intelligence. This powerful suite is  composed of tools  which helps in providing best solutions for  Business Intelligence  and  Data Mining Queries . This tool uses  Visual studio  along with   SQL server . It empowers users to gain access to accurate and up-to-date information for  better decision making  in an organization. It offers different tools for different processes which are required in  Business Intelligence (BI) solutions . To Get in-depth knowledge of msbi by taking  msbi online training . MSBI is divided into 3 categories: SSIS  – SQL Server Integration Services – Integration tool.  This tool is used for integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to SQL Server etc. This tool is also used for bulk transactions in the database like inserting lacs of records at once. We can create the integration services mo...

Power Bi consumed my hard disk space

Image
Yes, I have to admit – my laptop is an old one. And yes, I never cleaned it up. New apps here, new data there. But I always thought that with 237 GB I’d be fine for a while. Instead, Power BI consumed my hard disk space! Today something weird happened. A query crashed. Being in the middle of downloading something about 360’000 rows from the Internet, an error message appeared (sorry, the message is in German). It says, that I‘m running out of storage. To get in-Depth knowledge on Power BI you can enroll for a live demo on  Power BI online training Ok, I aborted the query and began to clean up all the mess on my laptop. Problem solved! But hey, what happened? And what has PBI Desktop done to my storage? Findings Power Query stores data on the Hard Disk in path C:\User\USERNAME\AppData\Local\Microsoft\Power BI Desktop\.  Learn more from  Power bi online course Let’s take a look. All right, more than 13.2 GB….. What a mess. But which share contains the most data? Ah, more th...

Why Use SSAS, SSIS & SSRS in MSBI

Image
  Microsoft SQL Server provides many tools to manage and utilize your data. SSAS  is Microsoft SQL Server’s Analysis Services which is an online analytical processing (OLAP), data mining and reporting tool used in Business Intelligence to make your data work for you. SSIS  stands for Sql Server Integration Services. The key power of SSIS is its data transformation and migration capability. When building a data warehouse or a data mart, the data needs to be extracted out of the various transactional systems and flat files, transformed and loaded to where it can then be analyzed and reported on. The data extraction, transformation and loading are known as ETL and is a common term in data migration and Business Intelligence. To get in depth knowledge on Microsoft business intelligence, enrich your skills on  msbi online training SSRS  stands for Sql Server Reporting Services. Once data is in its final state, either in the native transactional system or transformed ...

Power BI Mobile – you are in control

Image
 We put great emphasis on building delightful experiences in Power BI mobile apps. Our goal is to help you achieve maximum productivity by providing simple and intuitive data and insight consumption experiences. But different people have different needs and habits, and the experience one person prefers and enjoys is not always as easy to use for someone else. Therefore, we have decided to put you in control and allow you to decide how some elements in the Power BI mobile app behave. Introducing Interaction settings Recently we’ve added a new section to mobile app settings called Interaction. This section has several items that you can configure to define how the app behaves: To get in-Depth knowledge on Power BI you can enroll for a live demo on     Power BI online training   Single tap in reports (phone only) : When single tap is turned on, you tap only once on a visual, button, or slicer to start interacting with its data. When single tap is turned off, you ha...

10 essential UI (user-interface) design tips

Image
  web design is a relatively new discipline, it owes a lot to the scientific study of human-computer interaction (HCI). And these 9 handy guidelines straight from HCI research will help you focus on your users when designing websites and apps. Interface design, which focuses on the layout of functionality of interfaces, is a subset of user experience design, which focuses on the bigger picture: that is, the whole experience, not just the interface. To get in depth knowledge on UI, enrich your skills on UI online training Course 1. Know your users Above all else, you have to know who your users are—inside and out. That means knowing all the demographic data your analytics app(s) can pull, yes. But more importantly, it means knowing what they need, and what stands in the way of them achieving their goals. Getting to that level of empathy requires more than careful analysis of stats. It requires getting to know the people who use your website. It means speaking with them face to face...