As power forward Bong Quinto and point guard John Calvo put to rest rumors that they’re leaving Letran, the Knights are expected to be at full-strength against the Mapua Cardinals in their NCAA Season 93 basketball tournament debut.“I’m just happy we’re a complete team now,” said Letran coach Jeff Napa.ADVERTISEMENT Pagasa: Kammuri now a typhoon, may enter PAR by weekend Pagasa: Storm intensifies as it nears PAR Don’t miss out on the latest news and information. LATEST STORIES “The goal is to play hard every game and stay competitive,” said JRU coach Vergel Meneses.With former San Sebastian star CJ Perez finally suiting up, the Pirates of coach Topex Robinson have been installed as one of the favorites of the season.Sports Related Videospowered by AdSparcRead Next MOST READ China furious as Trump signs bills in support of Hong Kong Robredo: True leaders perform well despite having ‘uninspiring’ boss PLAY LIST 02:49Robredo: True leaders perform well despite having ‘uninspiring’ boss02:42PH underwater hockey team aims to make waves in SEA Games01:44Philippines marks anniversary of massacre with calls for justice01:19Fire erupts in Barangay Tatalon in Quezon City01:07Trump talks impeachment while meeting NCAA athletes02:49World-class track facilities installed at NCC for SEA Games Petron-F2 tiff up El Nido residents told to vacate beach homes Lacson: SEA Games fund put in foundation like ‘Napoles case’ Another vape smoker nabbed in Lucena LOOK: Jane De Leon meets fellow ‘Darna’ Marian Rivera Game time is at 4 p.m. on Tuesday at Filoil Flying V Centre in San Juan.Quinto and Calvo reportedly planned to transfer to La Salle in the UAAP, where they could have reunited with former Letran coach Aldin Ayo, before finally committing to stay with the Knights.FEATURED STORIESSPORTSSEA Games: Biñan football stadium stands out in preparedness, completionSPORTSPrivate companies step in to help SEA Games hostingSPORTSWin or don’t eat: the Philippines’ poverty-driven, world-beating pool starsThe duo will join forces with guard Rey Nambatac, who is suiting up for Letran for the final time this season.In other games, Jose Rizal U gets the first crack at Lyceum’s improved roster at 2 p.m., while St. Benilde, which is in the midst of rebuilding its program under new coach TY Tang, also makes its season debut against Perpetual Help at noon. Ethel Booba on hotel’s clarification that ‘kikiam’ is ‘chicken sausage’: ‘Kung di pa pansinin, baka isipin nila ok lang’ View comments
Prince William has ensured that close friends of his mother late Princess Diana are invited for his marriage to Kate Middleton atWestminster Abbey here on Friday.India will be represented at the wedding by the country’s High Commissioner to Britain Nalin Surie. Among thereligious leaders invited for the marriage include Anil Bhanot, afounding member of the Hindu Council UK. According to The Sunday Times, Sir Elton John, who sang at Diana’s funeral, is on the list along with Tessa Green, who used to chair the RoyalMarsden foundation trust – the cancer specialist centre which had beensupported by Diana.Sir John Major, former prime minister who was appointed guardian to princes William and Harry when Diana died, and William’s friend Joss Stone, the singer who performed at the concert for Diana, are also on the list.Diana’s family, including her brother Earl Spencer and his fiancee Karen Gordon, will sit behind the Middletons and their friends at the abbey, rather than on the royal family’s side of the aisle.Sarah Ferguson, Duchess of York, has not been invited.Among the foreign royals on the guest list are the Sultan of Brunei, PrinceAlbert II of Monaco and Princess Lalla Salma of Morocco.KingGeorge Tupou V, the ruler of the small Pacific nation of Tonga will also attend. The rulers of Middle Eastern countries are also invited. Theyinclude Crown Prince Salman bin Hamad Al Khalifa of Bahrain.Besides Bhanot, the list of religious leaders and representatives attendingincludes Lord Sacks, the chief rabbi; Cardinal Cormac Murphy-O’Connor,archbishop emeritus of Westminster.Bogoda Seelawimala, acting head monk of the London Buddhist Vihara, will be among the guests. He is the first Buddhist monk to be invitedto a royal wedding in Britain. Seelawimala has already offered someadvice to the couple, recommending meditation as one of the keys to asuccessful marriage. “Discuss your problems and meditate together eachmorning,” he said.The world of sports and entertainment are well represented with a list that includes Rowan Atkinson, the comedian andfriend of Prince Charles, and Guy Ritchie, the film director friend ofthe couple.The sports stars include Mike Tindall, the England rugby player and fiance of Zara Phillips, William’s cousin; David Beckham, the footballer and his wife Victoria; Ian Thorpe, the Australian Olympic swimmer; Gareth Thomas, the Walesrugby player who has spoken publicly about his homosexuality; Sir CliveWoodward, the former coach of the England rugby team; and Simon Johnson, head of England’s failed 2018 World Cup bid.Mario Testino, whotook the couple’s engagement photographs will also attend along with Tom Bradby, the ITN journalist who carried out their engagement interview,and Ben Fogle, the television presenter.A selection of cabientministers and their spouses have been invited including Prime MinisterDavid Cameron, Deputy Prime Minister Nick Clegg, Foreign SecretaryWilliam Hague and Home Secretary MsTheresa May. Ed Miliband, the Labourleader, will also attend.A war veteran who suffered near-fatal injuries including 75 per cent burns during anambush in Afghanistan will be at the royal wedding. Martyn Comptonserved alongside Prince William as a lance-corporal in the HouseholdCavalry.Also on the list are Susie Roberts, the widow ofWilliam’s friend Major Alexis Roberts who was killed in Afghanistan in2007, and Holly Dyer, whose sister Joanna, a close friend of William’sat Sandhurst, was killed by a roadside bomb in Iraq in 2007.Bryn and Emma Parry, founders of the charity Help For Heroes, and William’scolleague Sergeant Keith Best, a search and rescue winchman at RAFValley, are invited as well.advertisement
Paddler Neha Aggarwal (in pic) has been included in the Asian Games squad after Pooja Sahasrabudhe pulled out due to personal reasons. The 10-member table tennis team will be spearheaded by Sharath Kamal. “The team was selected on the basis of the players’ national and international ranking besides taking into account their current form,” Bhawani Mukherjee told MAIL TODAY.Squad: Men: A. Sharath Kamal, Soumyajit Ghosh, Harmeet Desai, Anthony Amalraj & Sanil Shetty. Women: Ankita Das, Madhurika Patkar, Poulomi Ghatak, Manika Batra and Neha Aggarwal.
Multi-talented entertainer and television personality Nick Cannon will serve as the Grand Marshal at the Walk to End Lupus Now event in Washington, D.C. on Saturday, April 19.Cannon will cut the opening ceremony ribbon and lead the more 4,000 walkers down Pennsylvania Avenue towards the Capitol, shedding light on the cruel mystery that is lupus. Cannon was diagnosed with lupus nephritis (lupus kidney disease) in 2012 and has been a tireless advocate for increased awareness of lupus and the importance of research.“Join me in our nation’s capital for the Lupus Foundation of America’s Walk to End Lupus Now event on April 19th. Together, we can rally public support for this disease and call attention to the importance of lupus research and participation in clinical trials,” says Nick Cannon. Nick Cannon’s participation in the DC Walk to End Lupus Now event is supported by Bristol-Myers Squibb.Cannon will be joined by Walk Ambassador and New England Patriots defensive back Tavon Wilson. Eileen Whelan, meteorologist for ABC7, will serve as the Master of Ceremonies.Lupus has impacted Wilson, a Washington, D.C. native, closely — both his aunt Regina and cousin Dionne are battling the disease.“When the opportunity came up to help create more awareness for this devastating disease, especially in my hometown, I jumped on it. I wanted to be a positive voice in the community because those with lupus deserve a cure for it,” said Wilson.Organized by the Lupus Foundation of America, Walk to End Lupus Now events are held in more than 60 cities across the country, making it the largest lupus walk program in the entire world The walk events bring together community members — people with lupus, friends, families, health care providers and celebrities — to raise money for lupus research and education programs, increase awareness of the disease and rally public support for those who feel the brutal impact of lupus.“The Lupus Foundation of America diligently works to ensure that federal and state funds are provided for lupus research and education programs. We must continue to make our voices heard and educate our elected officials about the impact of lupus on individuals and their families. The Walk to End Lupus Now in our nation’s capital serves as the perfect platform to accomplish this,” explained Sandra C. Raymond, President and CEO of Lupus Foundation of America. “More resources for research will further our efforts to find a cure for this unpredictable and devastating disease. We urge the community and Congress to join us in our fight to end lupus.”“Every dollar raised from Washington, D.C.‘s Walk to End Lupus Now event, supports the Lupus Foundation of America’s efforts to solve the mystery of lupus, while we continue to provide services to the thousands of residents that turn to us every year for answers and support,” said Jessica Gilbart President and CEO, Lupus Foundation of America, DMV ChapterRegistration for the walk is open online at DCLupusWalk.org. Participants can also create a personal fundraising page on the walk website to raise money, recruit new team members and get valuable fundraising tips.Source:PR Newswire
Chelsea assistant coach Gianfranco Zola claims that even though Eden Hazard may not be known for his industry off the ball, Chelsea still needs him to assist the team.The Belgium winger hasn’t really impressed in all his outing this term after he was deployed by new coach Sarri to play as a false nine.Chelsea defeated Tottenham 2-1 on penalties to reach the EFL Cup final on Thursday with Hazard scoring the Blues’ second goal in a second leg.“I was very much like Eden,” Zola told reporters, according to FourFourTwo.“I was a very positive player, I liked to move around the pitch, find the spots on the pitch where I could receive the ball, turn and make the damage to the opposition.Chelsea hat-trick hero Tammy Abraham hopes for more Andrew Smyth – September 14, 2019 Tammy Abraham hopes this season will be his big breakthrough at Chelsea after firing his first hat-trick for the club in Saturday’s 5-2 win at Wolves.“I was very, very similar and I do understand that. I believe we try to give him this but also to be an organised team defensively and offensively. Especially offensively. That’s why we ask Eden sometimes to put himself about in working hard.“I know that’s not his best quality. We understand that sometimes he needs to be fresh when he receives the ball. There is no doubt that we are on the same page. We want to find a common ground where he can get the best out of himself and the team can benefit from him.“Not only when he is scoring goals but when we have moments in the game where we need everybody to defend and everybody to press. That’s exactly what we are trying to do. Eden, I think, I have to be fair that he has been doing it.“He has been trying to do it. We are very demanding because we want to do it all the time. I am sure that we will find a compromise. I am not in a position to criticise a player like Eden. We believe, Maurizio said one thing, that the potential of Hazard is greater than the performances.“So he is not criticising what Eden is doing but he believes he can do much more for himself and the team. That’s all he is saying. This is the situation he wants Hazard to understand. Again, when we see his performances we look forward to seeing more and more.”
“We’d just seen that our audience had been changing in how they consume media,” Izzo says. “A big part of the change for us was the significant adoption of mobile and the engagement on social media.”Izzo says ALM made a big effort to transform into a digital-first company as a result. Another factor that contributed to the program’s creation was the significant increase in traffic on ALM websites from mobile devices, an increase of around 80 percent July over July from last year, according to Izzo.“Digital membership establishes a simple way for us to serve today’s subscribers and future subscribers with the online news content they want, when and where they want it,” says Jeffrey S. Litvack, chief digital officer at ALM in a statement.The free membership package includes digital access to five news articles every month from three controlled circulation publications, online access to news alerts, newsletters and previously archived news stories, and discounts on ALM products and services.“Subscribers will now have an easier way to click through to the content they want to read and non-subscribers will have a viable option for continuing to read by viewing five free stories a month,” Litvack contends.UPDATE: This movement of content from behind the paywall to the forefront with free access is a key advantage for subscribers, says Izzo.“The benefit to paid members is the ability to share the content to colleagues and potential clients,” Izzo says. “This ability to pass on a story to a colleague digitally makes that sharing process, either from social media or from your inbox newsletter, easier.”Digital membership holders have free and unlimited online access to three controlled circulation publications: Corporate Counsel, Law Technology News and The Asian Lawyer. ALM maintains that their four paid premium publications—Supreme Court Brief, Litigation Daily, New Jersey Law Journal Decision Alert and Delaware Business Court Insider—will continue to be accessible only to each publication’s subscribers. Paid subscribers will also maintain exclusive access to premium reports and briefings, including the Am Law 100 report.UPDATE: The decision to only allow five free news articles per monthly cycle was a strategic move on ALM’s part.“We want non-paid subscribers to test, trial, read and consume at least five articles a month across the network,” Izzo contends. “We felt that five was reflective of the engagement level of our readers on a daily, weekly and monthly basis.”More on this topic ALM Forms New Marketing Services Team InsideCounsel Folds Print Edition People on the Move | 5.17.12 ALM Newsletter Open Rates Jump 60 Percent After Mobile Optimization ALM Expands Regional Publishing Services Jeffrey LitvackJust In Meredith Corp. Makes Digital-Side Promotions | People on the Move Bonnier Corp. Terminates Editor-in-Chief for Ethics Breach The Atlantic Names New Global Marketing Head | People on the Move BabyCenter Sold to Ziff Davis Parent J2 Media | News & Notes This Just In: Magazines Are Not TV Networks Four More Execs Depart SourceMedia in Latest RestructuringPowered by ALM is set to launch a free digital membership program for legal professionals later this month.The legal and commercial real estate news publisher is looking to expand its consumer base by offering a bundled news service package that includes five free articles a month, newsletters, news alerts and access to ALM’s database where some previously archived subscriber-only stories will now be made available. The digital reader program, launching August 23, 2013, is cost-free.UPDATE: The catalyst for the creation of the digital membership program, according to ALM SVP and chief marketing officer Lenny Izzo, is mainly consumer convenience.
The Praetorian Group has been expanding its public safety business rapidly since last year. Now, they’re branching out to the larger local government space with the acquisition of EfficientGov.Terms weren’t disclosed.Public safety—markets like fire and police departments, emergency management and corrections—can account for more than half of a municipality’s budget, says Alex Ford, CEO of Praetorian, but there’s another half his company didn’t have an entrance into. Areas like planning and development, education and transportation were untapped. Ford says the digital media model Praetorian uses in its current markets—a mix of analysis and news content, along with grant assistance and education—can be applied to an audience of municipal leaders as well.”Public safety is a subset of local government,” he says. “It’s a logical extension to take that model to the rest of local government with a similar mission.”He adds: “We see the same exact model that’s working so well for us in public safety applying to local government more broadly, accessing an opportunity that’s more than twice the size.”See also: Praetorian Buys Fire Chief Assets from Penton The EfficientGov acquisition doesn’t get them all the way there—at least as comprehensively as they serve the public safety market—but Praetorian now has a foothold with the decision makers that hold influence over multiple segments, inside and outside of public safety. Ford says the deal brings about 44,000 new government officials into the fold.EfficientGov will continue to operate as a standalone brand, but will aggregate content from Praetorian’s network of more than 15 sites, Ford says.Prior to the acquisition, the company also announced that John Suhler, formerly the head of private equity firm Veronis Suhler Stevenson, has joined Praetorian in an advisory role.”Since his retirement from VSS, he now has the opportunity to take a more formal role and is excited about our opportunity to scale and grow the business,” Ford says. “He has an incredible amount of experience and knowledge of how to grow digital media companies. His connections are probably, bar none, some of the best in the media world, so he’s going to be a great asset.”
Ranveer Singh, Deepika PadukoneInstagramMuch to the fascination of everyone present at the location, Deepika Padukone, who is also a sportsperson, played cricket with the entire team of her upcoming film ’83, in between breaks on the sets. During the time out of the schedule of the shoot, Deepika would play cricket and was doing a baller job at it!Playing cricket along with the whole cast, also helped them bond and know each other better. In ’83, Deepika is playing the role of Romi Dev, wife to Kapil Dev, alongside hubby Ranveer Singh who is playing the role of Kapil Dev. The movie is based on the life of Kapil Dev and how he steered India to the world cup victory of 1983 Cricket World Cup.Having seen the life of a sportsman at close quarters and living with an Internationally acclaimed player, helped her understand the role of Romi Dev better. She has seen exactly what it took for her mother to be a wife to a sportsman who has to dedicate a majority of his life to his sport and bring glory to the country on representing it abroad and knows all the sacrifices and the toll it takes on their personal lives.Deepika has closely seen the whole life of her parents and one is excited to see it reflected on screen with the release of ’83 with her coming on screens as a cricketer’s wife.Apart from this, the actress is playing the role of an acid attack survivor in her upcoming film ‘Chapaak’, which is based on the life of Laxmi Aggarwal.The year 2020 will be special as both her upcoming films are releasing in the same year and interestingly, both the characters Laxmi Agarwal and Romi Dev are real-life characters with the heavy background behind them, making it a year of promising portrayals by the actress.
BNP chairperson Khaleda ZiaBangladesh Nationalist Party (BNP) chairperson Khaleda Zia on Saturday said her party wants the next election to be held under a non-party neutral government so that all political parties can join it.”We want multiparty democracy to be restored in the country and the next election to be held in a free and fair manner with the participation of all parties,” she said.”But the election must be held under a neutral administration. Or else, it won’t be possible to hold an impartial election,” she added.The BNP chief came up with the remarks while exchanging greetings with the Christian community on the occasion of the Christmas Day.Bangladesh Christian Association arranged the programme at the BNP chairperson’s Gulshan office.Khaleda alleged that the government is again trying to hold a 5-January-like unilateral election to hang onto power.She also came down hard on the government for what she said its repressive acts to weaken BNP.Khaleda voiced concern over the growing abuse of drugs by the young generation.”The ruling party men are involved in drug trading. And they’re working to destroy the young generation with it. Many of them were arrested but they have not been punished,” she said.Mentioning that the country is passing through a critical time, the BNP chief urged people of all religions and communities to get united to get rid of it.Later, Khaleda cut a cake with the Christian community members marking the Christmas Day.The BNP chief also wished the Christian community members a happy and prosperous life.
Parvez Sarker. File PhotoA mid-ranking leader of ruling Bangladesh Awami League (AL), who was abducted from the capital’s Lalmatia area on Friday, was rescued from Kanchan bridge in Purbachal city of the capital early Saturday.Miscreants released Parvez Hossain Sarker, a member of Cumilla district (North) unit Awami League and former chairman of Titas upazila parishad, around 12:30am, Mohammadpur police station officer-in-charge Jamal Uddin Mir said.Later, the AL leader contacted his family over phone, reports UNB.Being informed, a team of police along with family members rescued him from the area.Parvez, however, could not tell anything to police instantly as he was feeling drowsy, said the OC.Earlier, unidentified miscreants picked up Parvez while he was returning home after saying his Juma prayers at Lalmatia Minar Mosque around 2:00pm on Friday.
To embed this piece of audio in your site, please use this code: Share 00:00 /10:16 The Houston Independent School District Board just launched a series of meetings seeking input from the community for the district’s superintendent search. Trustees are asking what qualities and traits the community wants in the district’s next leader.HISD says it will use the feedback to finalize what it’s looking for in a permanent superintendent and begin searching for candidates.The district has been without a permanent leader since Richard Carranza left the post last year.In the audio above, we turn to a panel of community members to learn what it is they want in their next superintendent.Joining Houston Matters host Craig Cohen are Dr. Jasmine Jenkins, executive director for Houstonians for Great Public Schools, and Heather Golden, a parent, public school advocate, and community volunteer. X Listen
Two young Nokota mares. Image: Wikipedia. Most other domestic animals such as cows, sheep and goats by contrast appear to have evolved from a relatively small pool, likely shortly before horses followed suit.Interestingly, horses appear in cave art as early as 30,000 years ago, which suggests that early humans certainly knew about them and likely killed them for food for twenty thousand years before the idea of taming them came about which ultimately led to domestication.To trace back the horse’s lineage, the research team tested mitochondrial DNA (which is passed down only on the mother’s side) samples from modern horses living in the Americas, Europe, Asia and the Middle East. This allowed them to follow the genetic line from the single mare to the eighteen gene clusters that show that people in several different places learned to domesticate horses and to use them for their own specific purposes. Previous researchers looking into horse lineage had used only a portion of DNA known as the control region, which wasn’t enough to provide a complete profile.Prior to this new research many scholars had attributed the first domestication of the horse to the Eurasian Steppes, due to fossilized evidence showing horse domestication dating to around 3500 BC. This new research will undoubtedly cause new discussions in the community as a whole which will likely lead to new theories being developed to describe how so many different groups of people came to domestic horses in so many places. (PhysOrg.com) — For many years archeologists and other scientists have debated the origins of the domesticated horse. Nailing down a time frame is important because many historians view the relationship between man and horse as one of the most important in the development of our species. Horses allowed early people to hunt for faster prey, to wander farther than before and to create much bigger farms due to pulling plows. Now, new evidence has come to light suggesting that all modern horses, which are believed to have been domesticated approximately 10,000 years ago, descended from one mare around 140,000 years ago. The new evidence comes from a team made up of international researchers who, as they describe in their paper published in the Proceedings of the National Academy of Sciences, say that DNA evidence shows that the horse subsequently diverged into 18 different genetic lines, suggesting that domestication occurred independently in many places throughout the world. © 2011 PhysOrg.com Citation: MtDNA tests trace all modern horses back to single ancestor 140,000 years ago (2012, January 31) retrieved 18 August 2019 from https://phys.org/news/2012-01-mtdna-modern-horses-ancestor-years.html Explore further Ancient wild horses help unlock past Journal information: Proceedings of the National Academy of Sciences More information: Mitochondrial genomes from modern horses reveal the major haplogroups that underwent domestication, PNAS, Published online before print January 30, 2012, doi: 10.1073/pnas.1111637109AbstractArchaeological and genetic evidence concerning the time and mode of wild horse (Equus ferus) domestication is still debated. High levels of genetic diversity in horse mtDNA have been detected when analyzing the control region; recurrent mutations, however, tend to blur the structure of the phylogenetic tree. Here, we brought the horse mtDNA phylogeny to the highest level of molecular resolution by analyzing 83 mitochondrial genomes from modern horses across Asia, Europe, the Middle East, and the Americas. Our data reveal 18 major haplogroups (A–R) with radiation times that are mostly confined to the Neolithic and later periods and place the root of the phylogeny corresponding to the Ancestral Mare Mitogenome at ∼130–160 thousand years ago. All haplogroups were detected in modern horses from Asia, but F was only found in E. przewalskii—the only remaining wild horse. Therefore, a wide range of matrilineal lineages from the extinct E. ferus underwent domestication in the Eurasian steppes during the Eneolithic period and were transmitted to modern E. caballus breeds. Importantly, now that the major horse haplogroups have been defined, each with diagnostic mutational motifs (in both the coding and control regions), these haplotypes could be easily used to (i) classify well-preserved ancient remains, (ii) (re)assess the haplogroup variation of modern breeds, including Thoroughbreds, and (iii) evaluate the possible role of mtDNA backgrounds in racehorse performance. This document is subject to copyright. Apart from any fair dealing for the purpose of private study or research, no part may be reproduced without the written permission. The content is provided for information purposes only.
Microsoft Power BI Desktop contains a rich set of data source connectors and transformation capabilities that support the integration and enhancement of source data. These features are all driven by a powerful functional language and query engine, M, which leverages source system resources when possible and can greatly extend the scope and robustness of the data retrieval process beyond the possibilities of the standard query editor interface alone. As with almost all BI projects, the design and development of the data access and retrieval process has great implications for the analytical value, scalability, and sustainability of the overall Power BI solution. Our article is an excerpt from the book Microsoft Power BI Cookbook, written by Brett Powell. This book shows how to leverage Microsoft Power BI and the development tools to create better data driven analytics and visualizations. In this article, we dive into Power BI Desktop’s Get Data experience and go through the process of establishing and managing data source connections and queries. Examples are provided of using the Query Editor interface and the M language directly to construct and refine queries to meet common data transformation and cleansing needs. In practice and as per the examples, a combination of both tools is recommended to aid the query development process. Viewing and analyzing M functions Every time you click on a button to connect to any of Power BI Desktop’s supported data sources or apply any transformation to a data source object, such as changing a column’s data type, one or multiple M expressions are created reflecting your choices. These M expressions are automatically written to dedicated M documents and, if saved, are stored within the Power BI Desktop file as Queries. M is a functional programming language like F#, and it’s important that Power BI developers become familiar with analyzing and later writing and enhancing the M code that supports their queries. Getting ready Build a query through the user interface that connects to the AdventureWorksDW2016CTP3 SQL Server database on the ATLAS server and retrieves the DimGeography table, filtered by United States for English. Click on Get Data from the Home tab of the ribbon, select SQL Server from the list of database sources, and provide the server and database names. For the Data Connectivity mode, select Import. A navigation window will appear, with the different objects and schemas of the database. Select the DimGeography table from the Navigation window and click on Edit. In the Query Editor window, select the EnglishCountryRegionName column and then filter on United States from its dropdown. Figure 2: Filtering for United States only in the Query Editor At this point, a preview of the filtered table is exposed in the Query Editor and the Query Settings pane displays the previous steps. Figure 3: The Query Settings pane in the Query Editor How to do it Formula Bar With the Formula Bar visible in the Query Editor, click on the Source step under Applied Steps in the Query Settings pane. You should see the following formula expression: Figure 4: The SQL.Database() function created for the Source step Click on the Navigation step to expose the following expression: Figure 5: The metadata record created for the Navigation step The navigation expression (2) references the source expression (1) The Formula Bar in the Query Editor displays individual query steps, which are technically individual M expressions It’s convenient and very often essential to view and edit all the expressions in a centralized window, and for this, there’s the Advanced Editor M is a functional language, and it can be useful to think of query evaluation in M as similar to Excel spreadsheet formulas in which multiple formulas can reference each other. The M engine can determine which expressions are required by the final expression to return and evaluate only those expressions. Configuring Power BI Development Tools, the display setting for both the Query Settings pane and the Formula bar should be enabled as GLOBAL | Query Editor options. Figure 6: Global layout options for the Query Editor Alternatively, on a per file basis, you can control these settings and others from the View tab of the Query Editor toolbar. Figure 7: Property settings of the View tab in the Query Editor Advanced Editor window Given its importance to the query development process, the Advanced Editor dialog is exposed on both the Home and View tabs of the Query Editor. It’s recommended to use the Query Editor when getting started with a new query and when learning the M language. After several steps have been applied, use the Advanced Editor to review and optionally enhance or customize the M query. As a rich, functional programming language, there are many M functions and optional parameters not exposed via the Query Editor; going beyond the limits of the Query Editor enables more robust data retrieval and integration processes. Figure 8: The Home tab of the Query Editor Click on Advanced Editor from either the View or Home tabs (Figure 8 and Figure 9, respectively). All M function expressions and any comments are exposed Figure 9: The Advanced Editor view of the DimGeography query When developing retrieval processes for Power BI models, consider these common ETL questions: How are our queries impacting the source systems? Can we make our retrieval queries more resilient to changes in source data such that they avoid failure? Is our retrieval process efficient and simple to follow and support or are there unnecessary steps and queries? Are our retrieval queries delivering sufficient performance to the BI application? Is our process flexible such that we can quickly apply changes to data sources and logic? M queries are not intended as a substitute for the workloads typically handled by enterprise ETL tools such as SSIS or Informatica. However, just as BI professionals would carefully review the logic and test the performance of SQL stored procedures and ETL packages supporting their various cubes and reports environment, they should also review the M queries created to support Power BI models and reports. How it works Two of the top performance and scalability features of M’s engine are Query Folding and Lazy Evaluation. If possible, the M queries developed in Power BI Desktop are converted (folded) into SQL statements and passed to source systems for processing. M can also reduce the required resources for a given query by ignoring any unnecessary or redundant steps (variables). M is a case-sensitive language. This includes referencing variables in M expressions (RenameColumns versus Renamecolumns) as well as the values in M queries. For example, the values “Apple” and “apple” are considered unique values in an M query; the Table.Distinct() function will not remove rows for one of the values. Variable names in M expressions cannot have spaces without a hash sign and double quotes. Per Figure 10, when the Query Editor graphical interface is used to create M queries this syntax is applied automatically, along with a name describing the M transformation applied. Applying short, descriptive variable names (with no spaces) improves the readability of M queries. Query folding The query from this recipe was “folded” into the following SQL statement and sent to the ATLAS server for processing. Figure 10: The SQL statement generated from the DimGeography M query Right-click on the Filtered Rows step and select View Native Query to access the Native Query window from Figure 11: Figure 11: View Native Query in Query Settings Finding and revising queries that are not being folded to source systems is a top technique for enhancing large Power BI datasets. See the Pushing Query Processing Back to Source Systems recipe of Chapter 11, Enhancing and Optimizing Existing Power BI Solutions for an example of this process. M query structure The great majority of queries created for Power BI will follow the let…in structure as per this recipe, as they contain multiple steps with dependencies among them. Individual expressions are separated by commas. The expression referred to following the in keyword is the expression returned by the query. The individual step expressions are technically “variables”, and if the identifiers for these variables (the names of the query steps) contain spaces then the step is placed in quotes, and prefixed with a # sign as per the Filtered Rows step in Figure 10. Lazy evaluation The M engine also has powerful “lazy evaluation” logic for ignoring any redundant or unnecessary variables, as well as short-circuiting evaluation (computation) once a result is determinate, such as when one side (operand) of an OR logical operator is computed as True. The order of evaluation of the expressions is determined at runtime; it doesn’t have to be sequential from top to bottom. In the following example, a step for retrieving Canada was added and the step for the United States was ignored. Since the CanadaOnly variable satisfies the overall let expression of the query, only the Canada query is issued to the server as if the United States row were commented out or didn’t exist. Figure 12: Revised query that ignores Filtered Rows step to evaluate Canada only View Native Query (Figure 12) is not available given this revision, but a SQL Profiler trace against the source database server (and a refresh of the M query) confirms that CanadaOnly was the only SQL query passed to the source database. Figure 13: Capturing the SQL statement passed to the server via SQL Server Profiler trace There’s more Partial query folding A query can be “partially folded”, in which a SQL statement is created resolving only part of an overall query The results of this SQL statement would be returned to Power BI Desktop (or the on-premises data gateway) and the remaining logic would be computed using M’s in-memory engine with local resources M queries can be designed to maximize the use of the source system resources, by using standard expressions supported by query folding early in the query process Minimizing the use of local or on-premises data gateway resources is a top consideration Limitations of query folding No folding will take place once a native SQL query has been passed to the source system. For example, passing a SQL query directly through the Get Data dialog. The following query, specified in the Get Data dialog, is included in the Source Step: Figure 14: Providing a user defined native SQL query Any transformations applied after this native query will use local system resources. Therefore, the general implication for query development with native or user-defined SQL queries is that if they’re used, try to include all required transformations (that is, joins and derived columns), or use them to utilize an important feature of the source database not being utilized by the folded query, such as an index. Not all data sources support query folding, such as text and Excel files. Not all transformations available in the Query Editor or via M functions directly are supported by some data sources. The privacy levels defined for the data sources will also impact whether folding is used or not. SQL statements are not parsed before they’re sent to the source system. The Table.Buffer() function can be used to avoid query folding. The table output of this function is loaded into local memory and transformations against it will remain local. We have discussed effective techniques for accessing and retrieving data using Microsoft Power BI. Do check out this book Microsoft Power BI Cookbook for more information on using Microsoft power BI for data analysis and visualization. Read Next: Expert Interview: Unlocking the secrets of Microsoft Power BI Tutorial: Building a Microsoft Power BI Data Model Expert Insights:Ride the third wave of BI with Microsoft Power BI
Tags: Australia, Travel Alert Posted by Wednesday, August 3, 2016 SYDNEY, AUSTRALIA — International air passengers are being warned of potential disruption and delays when union members in Australia’s Department of Immigration and Border Protection go on strike for 24 hours on Aug. 12.Staff including Border Force officers will walk off the job from midnight on Aug. 12 at international airports, ports and other sites around the country. Additionally, quarantine and biosecurity staff at airports will also strike for a one-hour stop-work meeting on that day.Departing and arriving passengers on international flights are advised to allow for extra time and be prepared for possible delays during the industrial action.A release from the Community & Public Sector Union states:“We have written to Prime Minister Malcolm Turnbull seeking an urgent meeting to resolve his Government’s public sector bargaining mess. We’re also preparing to take action in the Fair Work Commission around the Government’s lack of good faith in bargaining and resume our successful community campaigning to hold MPs and Senators to account.”More news: Can you guess the one and only hotel company to rank on Indeed’s Top Workplaces in Canada list?“Prime Minister Turnbull can avert future strike action, including the prospect of broader industrial action across the Commonwealth public sector, by working with us to fix this mess. All these workers want is to hang onto their existing workplace rights, particularly family-friendly conditions and a fair wage outcome given their wages have been frozen for the past three years.” Travelweek Group Share << Previous PostNext Post >> Australian airport strikes expected next week